|
SELECT
o.obqva_id AS o_id,
oo.ime AS o_ime,
img.img_id AS i_id,
img.ifile AS ifile,
img.width_sr AS iw,
img.height_sr AS ih,
img.width_th AS itw,
img.height_th AS ith,
sp.selishte_id,
sp.ime,
oo.opis_txt AS o_descr,
o.tip_id AS o_tip,
ooe.ime AS e_ime,
ooe.opis_txt AS e_descr,
o.cena AS o_c,
o.cena_ot AS o_co,
o.cena_zakvm AS o_ckvm,
o.cena_otdo AS o_cotdo,
v.akronim AS v_akr,
o.text_id AS o_tid,
o.kvadratura AS o_k,
o.kvadratura_min AS o_km,
o.valuta_id AS o_valuta,
oo.url AS o_url,
o.aktivnost AS o_akt
FROM
obqva o
LEFT JOIN
obqva_opisanie oo
ON o.obqva_id=oo.obqva_id AND oo.ezik_id=2
LEFT JOIN
obqva_opisanie ooe
ON o.obqva_id=ooe.obqva_id AND ooe.ezik_id=2
LEFT JOIN
obqva_img oi
ON o.obqva_id = oi.obqva_id AND oi.red = 1
LEFT JOIN
img img
ON oi.img_id = img.img_id
LEFT JOIN
obqva_selishte os ON os.obqva_id = o.obqva_id
LEFT JOIN
selishte s
ON s.selishte_id = os.selishte_id
LEFT JOIN
selishte sup
ON s.selishte_up_id = sup.selishte_id
LEFT JOIN
obqva_imot oim
ON oim.obqva_id = o.obqva_id
LEFT JOIN
selishte_prevod sp
ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 2
LEFT JOIN
valuta v
ON o.valuta_id=v.valuta_id
WHERE
o.publikuvaj = 1 AND s.selishte_id IN (36,37,38,39,40,41,42,5642,5657,5658,5659,43,44,45,46,47,48,49,50,51,52,53,5667,5668,54,5643,5655,5656,55,5663,5664,56,5644,5660,57,58,59,60,62,63,5665,5666,64,65,66,5645,5661,5662,67,68,69,70,5651,5670,5671,5672,5673,5674,5675,5676,5677,5678,5680,5681,5682,5683,71,72,73,74,75,5641,5669,5691,5694,5695,5698,5704,5710,34) AND oim.imot_id IN (4,5,6,7,8,72,3) AND o.tip_id = 1 ORDER BY o.aktivnost, o.data_aktualizaciq DESC
#23 - Out of resources when opening file '/tmp/#sql_6f4c_661.MYI' (Errcode: 24)
|
